Problem Note 49134: Trying to share a LIBNAME connection when accessing DB2 on a z/OS system might result in "System abend 0C4"
 |  |  |  |  |
An abend 0C4 error might occur when you try to share connections with multiple librefs with the DB2 engine when running the SAS® system in a z/OS operating environment. The error might look similar to the following:
ERROR: System abend 0C4 occurred in module SASHOST function db2m_compare_conn_options at offset E56D64. ERROR: Traceback will be attempted... NOTE: Traceback called NOTE: Module Function Offset Line NOTE: -------- -------- ------ ---- NOTE: SASXDBI DBICON 000B78 0 NOTE: SASXDBI YHELASG 000808 0 NOTE: SASYH YYHLASN 0002F8 0 NOTE: SASYH YHLASN2 000AC4 0 NOTE: SASXSHEL YTLIBF 000A38 0 NOTE: SASXSHEL YASANY 000632 0 NOTE: SASXSHEL YASANY2 000142 0 NOTE: SASXSHEL YTTKNX 001E6E 0 NOTE: SASXSHEL YALEXEC 001F96 0 NOTE: SASXSHEL YALINLN 000516 0
To work around the issue, do either of the following when you are attempting to share DB2 connections:
- Explicitly list the DB2 subsystem using the SSID= option
- Or use the SQL_FUNCTIONS=ALL option in each of the LIBNAME statements
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H16.html#49134A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J41.html#49134| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-02-28 10:08:53 |
| Date Created: | 2013-02-13 09:22:13 |